SELECT distinct demo.last_name"Surname",demo.first_name"FirstName",
CONCAT( "/", demo.demographic_no, "/" ) AS "Master File",
CONCAT( "", "eChart", "" ) AS "eChart",
demo.email"Email",demo.phone"Phone"
FROM preventions p, demographic demo
WHERE demo.year_of_birth <= (Year(CURDATE())-65)
AND demo.patient_status = 'AC'
AND demo.provider_no = {provider_no}
AND demo.demographic_no = p.demographic_no
AND demo.demographic_no
NOT IN
(SELECT p.demographic_no FROM preventions p WHERE p.prevention_type = 'Pneumovax')
ORDER BY demo.last_name
;
SELECT provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider
WHERE status='1'
AND provider_type='doctor'
AND ohip_no>1
ORDER BY provider_no;